﻿CREATE PROCEDURE [dbo].[proc_L_Reimbursement_Item_GetlistBYPID]
	(
		@PID VARCHAR(10)
	)
AS
	Select
	Id
	,Reason
	,Prices
	,[CateOneId]
      ,[CateOneName]
      ,[CateTwoId]
      ,[CateTwoName]
      ,[SubjectId]
      ,[SubjectName]
	FROM L_Reimbursement_Item WHERE pid=@PID
	RETURN